DECLARE myCursor CURSOR
      LOCAL
      FOR SELECT Name, Country FROM EMP

      DECLARE @Name char(20), @Country char(50)

      OPEN myCursor

      FETCH myCursor
            INTO @Name, @Country

      SELECT @Name,@Country

      CLOSE       myCursor

      DEALLOCATE  myCursor